--Generated Upgrade For Version 0.0.0.0.21
--Generated on 2013-02-03 14:04:04

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__PRODUCT_CATEGORY' and xtype = 'F')
ALTER TABLE [dbo].[Product] DROP CONSTRAINT [FK__PRODUCT_CATEGORY]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__ORDER_CUSTOMER' and xtype = 'F')
ALTER TABLE [dbo].[Order] DROP CONSTRAINT [FK__ORDER_CUSTOMER]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__EMPLOYEETERRITORY_EMPLOYEE' and xtype = 'F')
ALTER TABLE [dbo].[EmployeeTerritory] DROP CONSTRAINT [FK__EMPLOYEETERRITORY_EMPLOYEE]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__ORDER_EMPLOYEE' and xtype = 'F')
ALTER TABLE [dbo].[Order] DROP CONSTRAINT [FK__ORDER_EMPLOYEE]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK_REPORTSTO_EMPLOYEE_EMPLOYEE' and xtype = 'F')
ALTER TABLE [dbo].[Employee] DROP CONSTRAINT [FK_REPORTSTO_EMPLOYEE_EMPLOYEE]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__ORDERDETAIL_ORDER' and xtype = 'F')
ALTER TABLE [dbo].[OrderDetail] DROP CONSTRAINT [FK__ORDERDETAIL_ORDER]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__ORDERDETAIL_PRODUCT' and xtype = 'F')
ALTER TABLE [dbo].[OrderDetail] DROP CONSTRAINT [FK__ORDERDETAIL_PRODUCT]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__TERRITORY_REGION' and xtype = 'F')
ALTER TABLE [dbo].[Territory] DROP CONSTRAINT [FK__TERRITORY_REGION]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__ORDER_SHIPPER' and xtype = 'F')
ALTER TABLE [dbo].[Order] DROP CONSTRAINT [FK__ORDER_SHIPPER]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__PRODUCT_SUPPLIER' and xtype = 'F')
ALTER TABLE [dbo].[Product] DROP CONSTRAINT [FK__PRODUCT_SUPPLIER]
GO

--REMOVE FOREIGN KEY
if exists(select * from sysobjects where name = 'FK__EMPLOYEETERRITORY_TERRITORY' and xtype = 'F')
ALTER TABLE [dbo].[EmployeeTerritory] DROP CONSTRAINT [FK__EMPLOYEETERRITORY_TERRITORY]
GO

